package com.wuxiaoqin.server.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.wuxiaoqin.server.entity.Goodsstock;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author jobob
 * @since 2021-11-06
 */
public interface GoodsstockMapper extends BaseMapper<Goodsstock> {

    @Select("select `#{sSize}` from goodsStock where C_id=#{cId}")
    String stockNum(Integer cId, String sSize);
}
